{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Contractor Input","EV_Cover_Sheet","EV_CERT_II_Drill_Ops","EV_CERT_III_Drill_Ops","EV_CERT_IV_Drill_Ops","EV_Driller_Group","MD_MAC-ENG-MTP-007","Workbook Parameters"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":15,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Contractor Input","index":0,"n_rows":68,"n_cols":38,"rows_kept":68,"cut":false,"hidden":false,"merged":[[15,13,15,22],[15,23,15,29],[15,30,15,31],[16,13,16,22],[16,23,16,29],[2,13,2,16],[2,17,2,31],[3,13,3,16],[3,17,3,31],[4,13,4,16],[4,17,4,31],[21,13,21,22],[21,23,21,31],[5,13,5,16],[5,17,5,31],[11,13,11,31],[8,17,8,31],[8,13,8,16],[16,30,16,31],[17,13,17,22],[17,30,17,31],[13,13,13,22],[13,23,13,29],[13,30,13,31],[14,13,14,22],[14,23,14,29],[14,30,14,31],[1,13,1,31],[32,19,32,25],[17,23,17,29],[30,13,30,22],[24,13,24,22],[24,23,24,31],[30,23,30,26],[30,27,30,31],[27,13,27,31],[28,13,28,31],[29,13,29,22],[29,23,29,26],[29,27,29,31],[12,30,12,31],[22,23,22,31],[20,13,20,31]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Competence Verification & Authorisation - Driller Roles\nMAC-STE-FRM-243 Version 1.0\nSection 1 - Contractor Information (Always use/download latest form from nswecinductions.com.au )"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Name:"]
[null,null,null,null,null,null,null,null,null,"AdminMode",null,null,null,"Pegasus Number:",null,null,null,""]
[null,null,null,null,null,null,null,null,null,false,null,null,null,"Contracting Company:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"MAC Site Contact:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Section 2 - Contractor Role Selection"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Section 3 - Mandatory Evidence"]
[null,null,"Driller","Driller Offsider","Driller Supervisor",null,null,null,null,"Worksheet Name cannot contain spaces, table name on sheet must be exactly as per worksheet name",null,null,null,"Mandatory Evidence\n- All attachments must be in .pdf format (Files added as attachments must be accessible when Email to MAC is generated)\n- Maximum size of email and attachments is not to exceed 25MB"]
[null,null,null,null,null,null,null,null,"Attachments","Worksheet Name","Selected",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"# Added"]
[null,null,null,"x",null,null,null,null,{"$f":"IF(INDEX(INDIRECT(SelectedEvidenceTable[[#This Row],[Worksheet Name]]),1)=0,0,COUNTA(INDIRECT(SelectedEvidenceTable[[#This Row],[Worksheet Name]])))","v":0},"EV_CERT_II_Drill_Ops",{"$f":"IF(COUNTIFS($C$11:$G$11,\"X\",C14:G14,\"x\")>=1,\"x\",\"\")","v":""},null,null,"Certificate II or III Drilling Operations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SelectedEvidenceTable[[#This Row],[Attachments]]","v":0}]
[null,null,"x",null,null,null,null,null,{"$f":"IF(INDEX(INDIRECT(SelectedEvidenceTable[[#This Row],[Worksheet Name]]),1)=0,0,COUNTA(INDIRECT(SelectedEvidenceTable[[#This Row],[Worksheet Name]])))","v":0},"EV_CERT_III_Drill_Ops",{"$f":"IF(COUNTIFS($C$11:$G$11,\"X\",C15:G15,\"x\")>=1,\"x\",\"\")","v":""},null,null,"Certificate III or IV Drilling Operations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SelectedEvidenceTable[[#This Row],[Attachments]]","v":0}]
[null,null,null,null,"x",null,null,null,{"$f":"IF(INDEX(INDIRECT(SelectedEvidenceTable[[#This Row],[Worksheet Name]]),1)=0,0,COUNTA(INDIRECT(SelectedEvidenceTable[[#This Row],[Worksheet Name]])))","v":0},"EV_CERT_IV_Drill_Ops",{"$f":"IF(COUNTIFS($C$11:$G$11,\"X\",C16:G16,\"x\")>=1,\"x\",\"\")","v":""},null,null,"Certificate IV or Diploma in Drilling Operations / Minerals Exploration",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SelectedEvidenceTable[[#This Row],[Attachments]]","v":0}]
[null,null,"x",null,null,null,null,null,{"$f":"IF(INDEX(INDIRECT(SelectedEvidenceTable[[#This Row],[Worksheet Name]]),1)=0,0,COUNTA(INDIRECT(SelectedEvidenceTable[[#This Row],[Worksheet Name]])))","v":0},"EV_Driller_Group",{"$f":"IF(COUNTIFS($C$11:$G$11,\"X\",C17:G17,\"x\")>=1,\"x\",\"\")","v":""},null,null,"Driller Certificates ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SelectedEvidenceTable[[#This Row],[Attachments]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Update To Form Required"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Section 4 - Mandatory Reading"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Mandatory Reading - Click 'Display Document' to display each mandatory reading file."]
[null,null,null,null,null,null,null,null,"Read","Worksheet Name","Selected"]
[null,null,"x","x","x",null,null,null,null,"MD_MAC-ENG-MTP-007",{"$f":"IF(COUNTIFS($C$11:$G$11,\"X\",C23:G23,\"x\")>=1,\"x\",\"\")","v":""},null,null,"MAC-ENG-MTP-007 Exploration Drilling Management Plan",null,null,null,null,null,null,null,null,null,{"$f":"IF($I23=\"Y\",\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,"Y",null,null,null,{"$f":"IF(COUNTIFS($C$11:$G$11,\"X\",C24:G24,\"x\")>=1,\"x\",\"\")","v":""},null,null,"No Mandatory Reading Required"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIFS($C$11:$G$11,\"X\",C25:G25,\"x\")>=1,\"x\",\"\")","v":""},null,null,"MAC-",null,null,null,null,null,null,null,null,null,"No"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Section 5 - Contractor Sign-off"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CONTRACT EQUIPMENT OPERATOR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"I confirm that the details provided are an accurate reflection of my knowledge and experience and that I have provided all required evidence and have read all mandatory reading documents.\n\nI also acknowledge that where I am required to work in additional areas, I will consult my Line Supervisor to ensure adequate training provisions have been met in accordance with Site requirements."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Name",null,null,null,null,null,null,null,null,null,"Date",null,null,null,"Signature"]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(INDEX(INDIRECT(J33),1)=0,0,COUNTA(INDIRECT(J33)))","v":0},"EV_Cover_Sheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]

{"sheet":"EV_Cover_Sheet","index":1,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[null,"Cover Sheet Attachment"]
[]
[]
[null,"Attached Documents For Evidence"]
[]
[]
[]
[null,"Business Rules for Attachments:"]
[]
[null,"- Ensure all fields in Section 1 are completed"]
[null,"- Ensure appropriate euquipment is selected only from Section 2"]
[null,"- Ensure all mandatory evidence is attached in Section 3"]
[null,"- Ensure all mandatory reading has been read in Section 4"]
[null,"- Ensure cover sheet is sgned and dated in Section 5 (Note: No digital signatures accepted, cover sheet to be printed and signed by contractor)"]
[null,"- Ensure attached evidence is clear and legible"]
[]
[null,"Failure to comply with the above business rules may result in submission being rejected"]

{"sheet":"EV_CERT_II_Drill_Ops","index":2,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
[null,"Certificate II or III Drilling Operations"]
[]
[]
[null,"Attached Documents For Evidence"]
[]
[]
[]
[null,"Business Rules for Attachments:"]
[]
[null,"- Ensure attached evidence is clear and legible"]
[null,"- Please attach one of the following"]
[]
[null,"- Certificate II in Drilling Operations or equivalent"]
[null,"- OR"]
[null,"- Certificate III in Drilling Operations or equivalent"]
[]
[null,"Issuing Statements of Attainment"]
[null,"1.     RTOs must include the following information on a statement of attainment:"]
[null,"a)    the name, RTO Code and logo of the issuing organisation;"]
[null,"b)    a list of units of competency (or modules where no units of competency exist) showing their full title and the national code for each unit of competency;"]
[null,"c)    the authorised signatory;"]
[null,"d)    the National Registered Training Logo;"]
[null,"e)    the issuing organisation’s seal, corporate identifier or unique watermark;"]
[null,"f)     the words ‘A statement of attainment is issued by a Registered Training Organisation when an individual has completed one or more accredited units’;"]
[]
[null,"Failure to comply with the above business rules may result in submission being rejected"]

{"sheet":"EV_CERT_III_Drill_Ops","index":3,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
[null,"Certificate III or IV Drilling Operations"]
[]
[]
[null,"Attached Documents For Evidence"]
[]
[]
[]
[null,"Business Rules for Attachments:"]
[]
[null,"- Ensure attached evidence is clear and legible"]
[null,"- Please attach one of the following"]
[]
[null,"- Certificate III in Drilling Operations or equivalent"]
[null,"- OR"]
[null,"- Certificate IV in Drilling Operations or equivalent"]
[]
[null,"Issuing Statements of Attainment"]
[null,"1.     RTOs must include the following information on a statement of attainment:"]
[null,"a)    the name, RTO Code and logo of the issuing organisation;"]
[null,"b)    a list of units of competency (or modules where no units of competency exist) showing their full title and the national code for each unit of competency;"]
[null,"c)    the authorised signatory;"]
[null,"d)    the National Registered Training Logo;"]
[null,"e)    the issuing organisation’s seal, corporate identifier or unique watermark;"]
[null,"f)     the words ‘A statement of attainment is issued by a Registered Training Organisation when an individual has completed one or more accredited units’;"]
[]
[null,"Failure to comply with the above business rules may result in submission being rejected"]

{"sheet":"EV_CERT_IV_Drill_Ops","index":4,"n_rows":28,"n_cols":2,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
[null,"Certificate IV or Diploma in Drilling Operations / Minerals Exploration"]
[]
[]
[null,"Attached Documents For Evidence"]
[]
[]
[]
[null,"Business Rules for Attachments:"]
[]
[null,"- Ensure attached evidence is clear and legible"]
[null,"- Please attach one of the following"]
[]
[null,"- Certificate IV or Diploma in Drilling Operations or equivalent"]
[null,"- Must including unit of competency RIINHB402E - Supervise drilling operations"]
[null,"- OR"]
[null,"- Certificate IV or Diploma in Minerals Exploration or equivalent"]
[null,"- Must including unit of competency RIINHB402E - Supervise drilling operations"]
[]
[null,"Issuing Statements of Attainment"]
[null,"1.     RTOs must include the following information on a statement of attainment:"]
[null,"a)    the name, RTO Code and logo of the issuing organisation;"]
[null,"b)    a list of units of competency (or modules where no units of competency exist) showing their full title and the national code for each unit of competency;"]
[null,"c)    the authorised signatory;"]
[null,"d)    the National Registered Training Logo;"]
[null,"e)    the issuing organisation’s seal, corporate identifier or unique watermark;"]
[null,"f)     the words ‘A statement of attainment is issued by a Registered Training Organisation when an individual has completed one or more accredited units’;"]
[]
[null,"Failure to comply with the above business rules may result in submission being rejected"]

{"sheet":"EV_Driller_Group","index":5,"n_rows":30,"n_cols":2,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
[null,"Driller Certificates"]
[]
[]
[null,"Attached Documents For Evidence"]
[]
[]
[]
[null,"Business Rules for Attachments:"]
[]
[null,"- Please attach certification in the style of Drilling being undertaken at Mt Arthur Coal, examples below"]
[null,"- Ensure attached evidence is clear and legible"]
[]
[null,"- RIINHB304 Conduct Air Drilling or equivalent"]
[null,"- OR"]
[null,"- RIINHB307 Conduct Conventional Core Drilling or equivalent"]
[null,"- OR"]
[null,"- RIINHB308 Conduct Wireline Core Drilling or equivalent"]
[null,"- OR"]
[null,"- RIINHB311 Conduct Mud Rotary Drilling or equivalent"]
[]
[null,"Issuing Statements of Attainment"]
[null,"1.     RTOs must include the following information on a statement of attainment:"]
[null,"a)    the name, RTO Code and logo of the issuing organisation;"]
[null,"b)    a list of units of competency (or modules where no units of competency exist) showing their full title and the national code for each unit of competency;"]
[null,"c)    the authorised signatory;"]
[null,"d)    the National Registered Training Logo;"]
[null,"e)    the issuing organisation’s seal, corporate identifier or unique watermark;"]
[null,"f)     the words ‘A statement of attainment is issued by a Registered Training Organisation when an individual has completed one or more accredited units’;"]
[]
[null,"Failure to comply with the above business rules may result in submission being rejected"]

{"sheet":"MD_MAC-ENG-MTP-007","index":6,"n_rows":9,"n_cols":17,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[null,null,null,"Document Ipick Link:","No Longer Required",null,null,null,null,"Document Name:","No Longer Required",null,null,null,null,"Ipick Document: ","Yes"]
[]
[]
[]
[null,"Please navigate to Tempo and read the latest version of this document. See below QRG for details on how to access and navigate Tempo"]
[]
[]
[]
[null,"I have read and understood this document"]

{"sheet":"Workbook Parameters","index":7,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[]
[]
["MACEmailToAddress","nswec.voc@bhp.com"]
["MACEmailCCAddress"]
["MACEmailSubject",{"$f":"ContractorPegasusNumber&\"_\" &ContractorCompany&\"_\"&ContractorName& \"_Contractor MAC VOC\"","v":"___Contractor MAC VOC"}]
["MACEmailBody","***DO NOT change the Subject heading of this email***\n\nHi,\n\nPlease see attached supporting documents for approval"]
["MACEmailBodyEquipMissing","***DO NOT change the Subject heading of this email***\n\nHi,\n\nThe following equipment type is not covered off within the current form.\n\nPlease update form to include \"Insert Missing Equipment Type Here\" and re-send updated form so I can complete the VOC Process"]